Avoid transaction log growth in DELETE operations

To avoid the transaction log growth, you can remove rows by batches within a WHILE cycle. This will help you to reduce the work of your transaction log.

I have a table with 20 Gb of data. I want to delete 90% of data let's say 18 gb data from the table with DELETE command with some condition.

Please advise me how to remove data from table with delete statement but info will not be saved in transaction log file. any way exist?

This topic describes how to delete data or log files in SQL Server by using SQL Server Management Studio or Transact-SQL. Before You Begin · Using SQL Server...

There is an alternative and faster way to DELETE data especially if there are no foreign key references and if the data to keep is very little.

The simplest option is to Truncate table, something like TRUNCATE TABLE LargeTable GO. Truncate table will simply empty the table, you cannot use WHERE clause ...

Truncate table will remove all the rows at once, and only if the table has no foreign keys, which makes it rather trivial.

If you want to remove data without logging, you can't be selective, you can use the TRUCATE statement, but there are all kinds of limits on that ...

The usual method is to delete in chunks and do transaction log backups between each chunk. It'll still use the same amount of log but the log backups mark the ...

We want to delete out all by the current 4 years worth of data but are concerned it will overfill the log. Is there a way to delete these ...